Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TaxGroupRuleID (FK)(PK) | System assigned unique identifier for the TaxGroupRule. | ID_RU_TX_GRP | Identity | integer | TaxRateRule(RU_TX_RT) |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | StoreHistory(LE_HST_STR) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | StoreHistory(LE_HST_STR) |
TaxRateRuleSequenceNumber (FK)(PK) | A squential number for theTaxRateRule, denoting the order of creation of the rules. | AI_TX_RT_RU | LineNumber | smallint | TaxRateRule(RU_TX_RT) |
TaxOnSalesTotalAmount | The total monetary amount of tax collected by the RetailStore. | MO_SLS_TX_TOT | Money | decimal(16,5) | |
TaxableSalesTotalAmount | The total monetary amount of taxable sales recorded by the RetailStore. | MO_SLS_TXBL_TOT | Money | decimal(16,5) | |
TaxExemptSalesTotalAmount | The total monetary amount of tax exempt sales recorded by the RetailStore. | MO_SLS_TX_EXM_TOT | Money | decimal(16,5) | |
TaxExemptSalesCount | The total number of tax exempt transactions recorded by the RetailStore. | QU_SLS_TX_EXM | QuantityTransactionCount | decimal(7,0) | |
TaxOnPurchasesTotalAmount | The total monetary amount of tax paid by the RetailStore on supply-side purchases. | MO_PCH_TX_TOT | Money | decimal(16,5) | |
TaxablePurchasesTotalAmount | The total monetary amount of taxable purchases made by the RetailStore on the 'supply-side' of the business. | MO_PCH_TXBL_TOT | Money | decimal(16,5) | |
TaxExemptPurchasesTotalAmount | The total monetary amount of tax exempt pruchases made by the RetailStore on the 'supply-side' of the business. | MO_PCH_TX_EXM_TOT | Money | decimal(16,5) | |
TaxExemptPurchasesCount | The number of tax exempt purchases made by the Retailer on the 'supply-side' of the business. | QU_PCH_TX_EXM | Quantity | DECIMAL(9,3) | |
TaxRateRulePercent | The percentage of the TaxRateRule being summarized. | PE_TX_RT | Percent | decimal(7,4) | |
TaxRateRuleAmount | The flat-tax amount of the TaxRateRule being summarized. | MO_TX_RT | MoneyShortRetail | decimal(7,2) | |